/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package org.serc.pensieve.data;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author Shani
 */
public class MeetingDao {

    public void getmeetings(String tempUsecase) {
       // throw new UnsupportedOperationException("Not yet implemented");
    int modUsecase = Integer.parseInt(tempUsecase);
    
    try {
            ResultSet res;
            DAO d = new DAO();
            Connection conn = d.makeConn();
            Statement stat = (Statement) conn.createStatement();
            String myQuery = "select DISTINCT * from NewInspection where InspectorID = "+modUsecase;
            System.out.println(myQuery);
            res = stat.executeQuery(myQuery);
            
            //ArrayList<Integer> tem
            while (res.next()) {
      // tempInspection.add(null)
                //Adding Inspection instance to list.
            }
          }
          catch (ClassNotFoundException ex)
          {
            Logger.getLogger(AdminDao.class.getName()).log(Level.SEVERE, null, ex);
          }
          catch (SQLException ex)
          {
            Logger.getLogger(AdminDao.class.getName()).log(Level.SEVERE, null, ex);
          }
        
    
    }

}
